Overview

The Top Bottom Store Sales Report allows a retailer to analyze the Top or Bottom performing stores. It shows the productivity based on sales.

Its purpose is to allow the retailer to quickly identify the Top or Bottom performing stores, and take action to improve the productivity.

Custom terminology allows you to define the retail terminology used within your business. Once defined, terminology automatically appears on criteria forms and reports. For more information on defining custom terminology refer to the article Custom Terminology.

Criteria Form

Refer to the article Report Criteria Form Standard Field Operation for help with the standard criteria form fields.

The following table describes the operation of non-standard fields where appropriate.

Field	Description
Report Date	This date field identifies a start or end date in generating the report. If the Period Type selected is Date Range it is the end date, otherwise it identifies as the start date.
Show	This drop-down field identifies whether to show the top or the bottom performing stores in the report.
Number	This fill-in field identifies the number of records to be shown in the report.
Measurement	This drop-down field identifies the measurement of the report to be generated.
Include Concession Stores	This check box determines whether the concession stores will be included in the report.

Reports

Refer to the section Understanding the Intelligence Store Data for help with the standard values included in Retail Arena reporting.

Remarks

Technical Reference

This section contains technical information about the various source objects for this report and parameters and customization that affect the reports operation. Refer to the article Form Customization and Parameters to understand how parameters, form customization, and security settings affect report and report criteria form operations.

Report Master

Report Index 1

Report Index 2

Report Index 3

Report Index 4

Report Index 5

Report Index 6

Property	Value
Form Name	Arena_TopBottomSalesAnalysis
Form Customization JScript File Name	Arena_TopBottomSalesAnalysis.js
Report Definition Name	Arena_TopBottomSalesAnalysis
Permission Name	Arena_TopBottomSalesAnalysis

Property	Value
RDL Name	TopBottomSalesAnalysis.rdl
Stored Procedure Name	Arena_TopBottomSalesAnalysis
Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter).	No
Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter)	No
Supports Currency Conversion	Yes
Honours the System::AggregateSalesIncludeNonInventory parameter.	No
Honours the System::SalesAndTargetsIncludeTax parameter.	No
Honours the System::UseConcessionStoreSales parameter.	No
Honours the System::ReleaseQuantityCalculationMethod parameter.	No
Uses the LiveDataViews::Store_Employee_Day_Values parameter.	No
Uses the LiveDataViews::Current_Stock parameter.	No

Property	Value
RDL Name	{Parity Point Report}
Stored Procedure Name	n/a
Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter).	No
Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter)	No
Supports Currency Conversion	Yes
Honours the System::AggregateSalesIncludeNonInventory parameter.	No
Honours the System::SalesAndTargetsIncludeTax parameter.	No
Honours the System::UseConcessionStoreSales parameter.	No
Honours the System::ReleaseQuantityCalculationMethod parameter.	No
Uses the LiveDataViews::Store_Employee_Day_Values parameter.	No
Uses the LiveDataViews::Current_Stock parameter.	No

Property	Value
RDL Name	{Sales as a % of Target Report}
Stored Procedure Name	n/a
Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter).	No
Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter)	No
Supports Currency Conversion	No
Honours the System::AggregateSalesIncludeNonInventory parameter.	No
Honours the System::SalesAndTargetsIncludeTax parameter.	No
Honours the System::UseConcessionStoreSales parameter.	No
Honours the System::ReleaseQuantityCalculationMethod parameter.	No
Uses the LiveDataViews::Store_Employee_Day_Values parameter.	No
Uses the LiveDataViews::Current_Stock parameter.	No

Property	Value
RDL Name	{Sales as a % of Last Year}
Stored Procedure Name	n/a
Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter).	No
Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter)	No
Supports Currency Conversion	No
Honours the System::AggregateSalesIncludeNonInventory parameter.	No
Honours the System::SalesAndTargetsIncludeTax parameter.	No
Honours the System::UseConcessionStoreSales parameter.	No
Honours the System::ReleaseQuantityCalculationMethod parameter.	No
Uses the LiveDataViews::Store_Employee_Day_Values parameter.	No
Uses the LiveDataViews::Current_Stock parameter.	No

Property	Value
RDL Name	{Wage as a % of Sales}
Stored Procedure Name	n/a
Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter).	No
Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter)	No
Supports Currency Conversion	No
Honours the System::AggregateSalesIncludeNonInventory parameter.	No
Honours the System::SalesAndTargetsIncludeTax parameter.	No
Honours the System::UseConcessionStoreSales parameter.	No
Honours the System::ReleaseQuantityCalculationMethod parameter.	No
Uses the LiveDataViews::Store_Employee_Day_Values parameter.	No
Uses the LiveDataViews::Current_Stock parameter.	No

Property	Value
RDL Name	TopBottomStoreProductivity.rdl
Stored Procedure Name	Arena_TopBottomStoreProductivity
Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter).	No
Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter)	No
Supports Currency Conversion	Yes
Honours the System::AggregateSalesIncludeNonInventory parameter.	No
Honours the System::SalesAndTargetsIncludeTax parameter.	No
Honours the System::UseConcessionStoreSales parameter.	No
Honours the System::ReleaseQuantityCalculationMethod parameter.	No
Uses the LiveDataViews::Store_Employee_Day_Values parameter.	No
Uses the LiveDataViews::Current_Stock parameter.	No

Arena User Documentation
Top Bottom Store Sales Report
Send Feedback